Record Field Values

Record fields may be searched for specific matching values using a specialized attribute type to query the field value. The syntax for querying record fields is:

(<record name>.<field name>[< = | <> | > | >= | < | <= ><search value>])

The record and field names are STRING values and should be enclosed in single quotes. Any one of the optional comparison operators can be used to focus the search on a specific subset of items which have the attached record. For example:

('Assembly Data'.'Base Cost' < 250.00)

will search for any items with the attached record whose base cost is less than 250.00 dollars.